﻿<%@ Control Language="C#" AutoEventWireup="true" CodeFile="TableColumn.ascx.cs" Inherits="UserControl_TableColumn" %>
<%@ Register Src="Tables.ascx" TagName="Tables" TagPrefix="uc1" %>
<uc1:Tables id="Tables1" runat="server">
</uc1:Tables>
&nbsp;<asp:Button ID="Button1" runat="server" /><br />
&nbsp; &nbsp;
<asp:LinkButton ID="LinkButton1" runat="server">全選</asp:LinkButton>
<asp:CheckBoxList ID="CheckBoxList1" runat="server" DataSourceID="SqlDataSource1"
    DataTextField="COLUMN_NAME" DataValueField="COLUMN_NAME" RepeatDirection="Horizontal"
    RepeatLayout="Flow">
</asp:CheckBoxList>
<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:MasertDB %>"
    SelectCommand="SELECT  *  FROM INFORMATION_SCHEMA.COLUMNS a WHERE table_name=@table_name ">
    <SelectParameters>
        <asp:Parameter Name="table_name" />
    </SelectParameters>
</asp:SqlDataSource>
